Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_HIST_SQLTEXT

`DBA_HIST_SQLTEXT` displays the text of SQL statements belonging to shared SQL cursors captured in the Workload Repository. This view captures information from `V$SQL` and is used with the `DBA_HIST_SQLSTAT` view.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`DBID` | `NUMBER` | `NOT NULL` | Database ID
`SQL_ID` | `VARCHAR2(13)` | `NOT NULL` | SQL identifier of the parent cursor in the library cache
`SQL_TEXT` | `CLOB` |  | Full text for the SQL statement exposed as a CLOB column
`COMMAND_TYPE` | `NUMBER` |  | Oracle command type definition